if object_id('BIMonitor.SSISServers') is not null
  drop table BIMonitor.SSISServers
go

create table BIMonitor.SSISServers
 (ServerID                 int identity(1,1) not null,
  Environment              varchar(75) not null,
  [Server]                 nvarchar(128) not null,

  constraint pk_SSISServers primary key(ServerID),
  constraint uq_SSISServers_Server unique (Environment,[Server]));